using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VICC_TXTKON
    {
        public DataRow Convert2ICC_TXTKON(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryICC_TXTKON(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["TXTIPIND"] = " ".PadRight(60 ); 
         dwReturn["TXT010"] = " ".PadRight(80 ); 
         dwReturn["TXT010HR"] = " ".PadRight(8 ); 
         dwReturn["TXT010DT"] = " ".PadRight(8 ); 
         dwReturn["TXT020"] = " ".PadRight(80 ); 
         dwReturn["TXT020HR"] = " ".PadRight(8 ); 
         dwReturn["TXT020DT"] = " ".PadRight(8 ); 
         dwReturn["TXT030"] = " ".PadRight(80 ); 
         dwReturn["TXT030HR"] = " ".PadRight(8 ); 
         dwReturn["TXT030DT"] = " ".PadRight(8 ); 
         dwReturn["TXT040"] = " ".PadRight(80 ); 
         dwReturn["TXT040HR"] = " ".PadRight(8 ); 
         dwReturn["TXT040DT"] = " ".PadRight(8 ); 
         dwReturn["TXT050"] = " ".PadRight(80 ); 
         dwReturn["TXT050HR"] = " ".PadRight(8 ); 
         dwReturn["TXT050DT"] = " ".PadRight(8 ); 
         dwReturn["TXT060"] = " ".PadRight(80 ); 
         dwReturn["TXT060HR"] = " ".PadRight(8 ); 
         dwReturn["TXT060DT"] = " ".PadRight(8 ); 
         dwReturn["TXT070"] = " ".PadRight(80 ); 
         dwReturn["TXT070HR"] = " ".PadRight(8 ); 
         dwReturn["TXT070DT"] = " ".PadRight(8 ); 
         dwReturn["TXT080"] = " ".PadRight(80 ); 
         dwReturn["TXT080HR"] = " ".PadRight(8 ); 
         dwReturn["TXT080DT"] = " ".PadRight(8 ); 
         dwReturn["TXT090"] = " ".PadRight(80 ); 
         dwReturn["TXT090HR"] = " ".PadRight(8 ); 
         dwReturn["TXT090DT"] = " ".PadRight(8 ); 
         dwReturn["TXT100"] = " ".PadRight(80 ); 
         dwReturn["TXT100HR"] = " ".PadRight(8 ); 
         dwReturn["TXT100DT"] = " ".PadRight(8 ); 
         dwReturn["TXT110"] = " ".PadRight(80 ); 
         dwReturn["TXT110HR"] = " ".PadRight(8 ); 
         dwReturn["TXT110DT"] = " ".PadRight(8 ); 
         dwReturn["TXT120"] = " ".PadRight(80 ); 
         dwReturn["TXT120HR"] = " ".PadRight(8 ); 
         dwReturn["TXT120DT"] = " ".PadRight(8 ); 
         dwReturn["TXT130"] = " ".PadRight(80 ); 
         dwReturn["TXT130HR"] = " ".PadRight(8 ); 
         dwReturn["TXT130DT"] = " ".PadRight(8 ); 
         dwReturn["TXT140"] = " ".PadRight(80 ); 
         dwReturn["TXT140HR"] = " ".PadRight(8 ); 
         dwReturn["TXT140DT"] = " ".PadRight(8 ); 
         dwReturn["TXT150"] = " ".PadRight(80 ); 
         dwReturn["TXT150HR"] = " ".PadRight(8 ); 
         dwReturn["TXT150DT"] = " ".PadRight(8 ); 
         dwReturn["TXT160"] = " ".PadRight(80 ); 
         dwReturn["TXT160HR"] = " ".PadRight(8 ); 
         dwReturn["TXT160DT"] = " ".PadRight(8 ); 
         dwReturn["TXT170"] = " ".PadRight(80 ); 
         dwReturn["TXT170HR"] = " ".PadRight(8 ); 
         dwReturn["TXT170DT"] = " ".PadRight(8 ); 
         dwReturn["TXT180"] = " ".PadRight(80 ); 
         dwReturn["TXT180HR"] = " ".PadRight(8 ); 
         dwReturn["TXT180DT"] = " ".PadRight(8 ); 
         dwReturn["TXT190"] = " ".PadRight(80 ); 
         dwReturn["TXT190HR"] = " ".PadRight(8 ); 
         dwReturn["TXT190DT"] = " ".PadRight(8 ); 
         dwReturn["TXT200"] = " ".PadRight(80 ); 
         dwReturn["TXT200HR"] = " ".PadRight(8 ); 
         dwReturn["TXT200DT"] = " ".PadRight(8 ); 
         dwReturn["TXT210"] = " ".PadRight(80 ); 
         dwReturn["TXT210HR"] = " ".PadRight(8 ); 
         dwReturn["TXT210DT"] = " ".PadRight(8 ); 
         dwReturn["TXT220"] = " ".PadRight(80 ); 
         dwReturn["TXT220HR"] = " ".PadRight(8 ); 
         dwReturn["TXT220DT"] = " ".PadRight(8 ); 
         dwReturn["TXT230"] = " ".PadRight(80 ); 
         dwReturn["TXT230HR"] = " ".PadRight(8 ); 
         dwReturn["TXT230DT"] = " ".PadRight(8 ); 
         dwReturn["TXT240"] = " ".PadRight(80 ); 
         dwReturn["TXT240HR"] = " ".PadRight(8 ); 
         dwReturn["TXT240DT"] = " ".PadRight(8 ); 
         dwReturn["TXT250"] = " ".PadRight(80 ); 
         dwReturn["TXT250HR"] = " ".PadRight(8 ); 
         dwReturn["TXT250DT"] = " ".PadRight(8 ); 
         dwReturn["TXT260"] = " ".PadRight(80 ); 
         dwReturn["TXT260HR"] = " ".PadRight(8 ); 
         dwReturn["TXT260DT"] = " ".PadRight(8 ); 
         dwReturn["TXT270"] = " ".PadRight(80 ); 
         dwReturn["TXT270HR"] = " ".PadRight(8 ); 
         dwReturn["TXT270DT"] = " ".PadRight(8 ); 
         dwReturn["TXT280"] = " ".PadRight(80 ); 
         dwReturn["TXT280HR"] = " ".PadRight(8 ); 
         dwReturn["TXT280DT"] = " ".PadRight(8 ); 
         dwReturn["TXT290"] = " ".PadRight(80 ); 
         dwReturn["TXT290HR"] = " ".PadRight(8 ); 
         dwReturn["TXT290DT"] = " ".PadRight(8 ); 
         dwReturn["TXT300"] = " ".PadRight(80 ); 
         dwReturn["TXT300HR"] = " ".PadRight(8 ); 
         dwReturn["TXT300DT"] = " ".PadRight(8 ); 
         dwReturn["TXT310"] = " ".PadRight(80 ); 
         dwReturn["TXT310HR"] = " ".PadRight(8 ); 
         dwReturn["TXT310DT"] = " ".PadRight(8 ); 
         dwReturn["TXT320"] = " ".PadRight(80 ); 
         dwReturn["TXT320HR"] = " ".PadRight(8 ); 
         dwReturn["TXT320DT"] = " ".PadRight(8 ); 
         dwReturn["TXT330"] = " ".PadRight(80 ); 
         dwReturn["TXT330HR"] = " ".PadRight(8 ); 
         dwReturn["TXT330DT"] = " ".PadRight(8 ); 
         dwReturn["TXT340"] = " ".PadRight(80 ); 
         dwReturn["TXT340HR"] = " ".PadRight(8 ); 
         dwReturn["TXT340DT"] = " ".PadRight(8 ); 
         dwReturn["TXT350"] = " ".PadRight(80 ); 
         dwReturn["TXT350HR"] = " ".PadRight(8 ); 
         dwReturn["TXT350DT"] = " ".PadRight(8 ); 
         dwReturn["TXT360"] = " ".PadRight(80 ); 
         dwReturn["TXT360HR"] = " ".PadRight(8 ); 
         dwReturn["TXT360DT"] = " ".PadRight(8 ); 
         dwReturn["TXT370"] = " ".PadRight(80 ); 
         dwReturn["TXT370HR"] = " ".PadRight(8 ); 
         dwReturn["TXT370DT"] = " ".PadRight(8 ); 
         dwReturn["TXT380"] = " ".PadRight(80 ); 
         dwReturn["TXT380HR"] = " ".PadRight(8 ); 
         dwReturn["TXT380DT"] = " ".PadRight(8 ); 
         dwReturn["TXT390"] = " ".PadRight(80 ); 
         dwReturn["TXT390HR"] = " ".PadRight(8 ); 
         dwReturn["TXT390DT"] = " ".PadRight(8 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapICC_TXTKON(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveICC_TXTKON(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryICC_TXTKON(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapICC_TXTKON(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertICC_TXTKON(dwLocal, ITXDBVERSION);
            }
            UpdateICC_TXTKON(dwLocal);
        }
        public void InsertICC_TXTKON(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO ICC_TXTKON(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryICC_TXTKON(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM ICC_TXTKON WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM ICC_TXTKON  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "ICC_TXTKON";
            Return = Result;
            return Return;
        }
        public void DeleteICC_TXTKON(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ICC_TXTKON   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateICC_TXTKON(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE ICC_TXTKON SET "
                    +"TXTIPIND= :TXTIPIND,"
                    +"TXT010= :TXT010,"
                    +"TXT010HR= :TXT010HR,"
                    +"TXT010DT= :TXT010DT,"
                    +"TXT020= :TXT020,"
                    +"TXT020HR= :TXT020HR,"
                    +"TXT020DT= :TXT020DT,"
                    +"TXT030= :TXT030,"
                    +"TXT030HR= :TXT030HR,"
                    +"TXT030DT= :TXT030DT,"
                    +"TXT040= :TXT040,"
                    +"TXT040HR= :TXT040HR,"
                    +"TXT040DT= :TXT040DT,"
                    +"TXT050= :TXT050,"
                    +"TXT050HR= :TXT050HR,"
                    +"TXT050DT= :TXT050DT,"
                    +"TXT060= :TXT060,"
                    +"TXT060HR= :TXT060HR,"
                    +"TXT060DT= :TXT060DT,"
                    +"TXT070= :TXT070,"
                    +"TXT070HR= :TXT070HR,"
                    +"TXT070DT= :TXT070DT,"
                    +"TXT080= :TXT080,"
                    +"TXT080HR= :TXT080HR,"
                    +"TXT080DT= :TXT080DT,"
                    +"TXT090= :TXT090,"
                    +"TXT090HR= :TXT090HR,"
                    +"TXT090DT= :TXT090DT,"
                    +"TXT100= :TXT100,"
                    +"TXT100HR= :TXT100HR,"
                    +"TXT100DT= :TXT100DT,"
                    +"TXT110= :TXT110,"
                    +"TXT110HR= :TXT110HR,"
                    +"TXT110DT= :TXT110DT,"
                    +"TXT120= :TXT120,"
                    +"TXT120HR= :TXT120HR,"
                    +"TXT120DT= :TXT120DT,"
                    +"TXT130= :TXT130,"
                    +"TXT130HR= :TXT130HR,"
                    +"TXT130DT= :TXT130DT,"
                    +"TXT140= :TXT140,"
                    +"TXT140HR= :TXT140HR,"
                    +"TXT140DT= :TXT140DT,"
                    +"TXT150= :TXT150,"
                    +"TXT150HR= :TXT150HR,"
                    +"TXT150DT= :TXT150DT,"
                    +"TXT160= :TXT160,"
                    +"TXT160HR= :TXT160HR,"
                    +"TXT160DT= :TXT160DT,"
                    +"TXT170= :TXT170,"
                    +"TXT170HR= :TXT170HR,"
                    +"TXT170DT= :TXT170DT,"
                    +"TXT180= :TXT180,"
                    +"TXT180HR= :TXT180HR,"
                    +"TXT180DT= :TXT180DT,"
                    +"TXT190= :TXT190,"
                    +"TXT190HR= :TXT190HR,"
                    +"TXT190DT= :TXT190DT,"
                    +"TXT200= :TXT200,"
                    +"TXT200HR= :TXT200HR,"
                    +"TXT200DT= :TXT200DT,"
                    +"TXT210= :TXT210,"
                    +"TXT210HR= :TXT210HR,"
                    +"TXT210DT= :TXT210DT,"
                    +"TXT220= :TXT220,"
                    +"TXT220HR= :TXT220HR,"
                    +"TXT220DT= :TXT220DT,"
                    +"TXT230= :TXT230,"
                    +"TXT230HR= :TXT230HR,"
                    +"TXT230DT= :TXT230DT,"
                    +"TXT240= :TXT240,"
                    +"TXT240HR= :TXT240HR,"
                    +"TXT240DT= :TXT240DT,"
                    +"TXT250= :TXT250,"
                    +"TXT250HR= :TXT250HR,"
                    +"TXT250DT= :TXT250DT,"
                    +"TXT260= :TXT260,"
                    +"TXT260HR= :TXT260HR,"
                    +"TXT260DT= :TXT260DT,"
                    +"TXT270= :TXT270,"
                    +"TXT270HR= :TXT270HR,"
                    +"TXT270DT= :TXT270DT,"
                    +"TXT280= :TXT280,"
                    +"TXT280HR= :TXT280HR,"
                    +"TXT280DT= :TXT280DT,"
                    +"TXT290= :TXT290,"
                    +"TXT290HR= :TXT290HR,"
                    +"TXT290DT= :TXT290DT,"
                    +"TXT300= :TXT300,"
                    +"TXT300HR= :TXT300HR,"
                    +"TXT300DT= :TXT300DT,"
                    +"TXT310= :TXT310,"
                    +"TXT310HR= :TXT310HR,"
                    +"TXT310DT= :TXT310DT,"
                    +"TXT320= :TXT320,"
                    +"TXT320HR= :TXT320HR,"
                    +"TXT320DT= :TXT320DT,"
                    +"TXT330= :TXT330,"
                    +"TXT330HR= :TXT330HR,"
                    +"TXT330DT= :TXT330DT,"
                    +"TXT340= :TXT340,"
                    +"TXT340HR= :TXT340HR,"
                    +"TXT340DT= :TXT340DT,"
                    +"TXT350= :TXT350,"
                    +"TXT350HR= :TXT350HR,"
                    +"TXT350DT= :TXT350DT,"
                    +"TXT360= :TXT360,"
                    +"TXT360HR= :TXT360HR,"
                    +"TXT360DT= :TXT360DT,"
                    +"TXT370= :TXT370,"
                    +"TXT370HR= :TXT370HR,"
                    +"TXT370DT= :TXT370DT,"
                    +"TXT380= :TXT380,"
                    +"TXT380HR= :TXT380HR,"
                    +"TXT380DT= :TXT380DT,"
                    +"TXT390= :TXT390,"
                    +"TXT390HR= :TXT390HR,"
                    +"TXT390DT= :TXT390DT,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("TXTIPIND", OracleType.NVarChar).Value = dwData["TXTIPIND"].ToString(); 
          or1.Parameters.Add("TXT010", OracleType.NVarChar).Value = dwData["TXT010"].ToString(); 
          or1.Parameters.Add("TXT010HR", OracleType.NVarChar).Value = dwData["TXT010HR"].ToString(); 
          or1.Parameters.Add("TXT010DT", OracleType.NVarChar).Value = dwData["TXT010DT"].ToString(); 
          or1.Parameters.Add("TXT020", OracleType.NVarChar).Value = dwData["TXT020"].ToString(); 
          or1.Parameters.Add("TXT020HR", OracleType.NVarChar).Value = dwData["TXT020HR"].ToString(); 
          or1.Parameters.Add("TXT020DT", OracleType.NVarChar).Value = dwData["TXT020DT"].ToString(); 
          or1.Parameters.Add("TXT030", OracleType.NVarChar).Value = dwData["TXT030"].ToString(); 
          or1.Parameters.Add("TXT030HR", OracleType.NVarChar).Value = dwData["TXT030HR"].ToString(); 
          or1.Parameters.Add("TXT030DT", OracleType.NVarChar).Value = dwData["TXT030DT"].ToString(); 
          or1.Parameters.Add("TXT040", OracleType.NVarChar).Value = dwData["TXT040"].ToString(); 
          or1.Parameters.Add("TXT040HR", OracleType.NVarChar).Value = dwData["TXT040HR"].ToString(); 
          or1.Parameters.Add("TXT040DT", OracleType.NVarChar).Value = dwData["TXT040DT"].ToString(); 
          or1.Parameters.Add("TXT050", OracleType.NVarChar).Value = dwData["TXT050"].ToString(); 
          or1.Parameters.Add("TXT050HR", OracleType.NVarChar).Value = dwData["TXT050HR"].ToString(); 
          or1.Parameters.Add("TXT050DT", OracleType.NVarChar).Value = dwData["TXT050DT"].ToString(); 
          or1.Parameters.Add("TXT060", OracleType.NVarChar).Value = dwData["TXT060"].ToString(); 
          or1.Parameters.Add("TXT060HR", OracleType.NVarChar).Value = dwData["TXT060HR"].ToString(); 
          or1.Parameters.Add("TXT060DT", OracleType.NVarChar).Value = dwData["TXT060DT"].ToString(); 
          or1.Parameters.Add("TXT070", OracleType.NVarChar).Value = dwData["TXT070"].ToString(); 
          or1.Parameters.Add("TXT070HR", OracleType.NVarChar).Value = dwData["TXT070HR"].ToString(); 
          or1.Parameters.Add("TXT070DT", OracleType.NVarChar).Value = dwData["TXT070DT"].ToString(); 
          or1.Parameters.Add("TXT080", OracleType.NVarChar).Value = dwData["TXT080"].ToString(); 
          or1.Parameters.Add("TXT080HR", OracleType.NVarChar).Value = dwData["TXT080HR"].ToString(); 
          or1.Parameters.Add("TXT080DT", OracleType.NVarChar).Value = dwData["TXT080DT"].ToString(); 
          or1.Parameters.Add("TXT090", OracleType.NVarChar).Value = dwData["TXT090"].ToString(); 
          or1.Parameters.Add("TXT090HR", OracleType.NVarChar).Value = dwData["TXT090HR"].ToString(); 
          or1.Parameters.Add("TXT090DT", OracleType.NVarChar).Value = dwData["TXT090DT"].ToString(); 
          or1.Parameters.Add("TXT100", OracleType.NVarChar).Value = dwData["TXT100"].ToString(); 
          or1.Parameters.Add("TXT100HR", OracleType.NVarChar).Value = dwData["TXT100HR"].ToString(); 
          or1.Parameters.Add("TXT100DT", OracleType.NVarChar).Value = dwData["TXT100DT"].ToString(); 
          or1.Parameters.Add("TXT110", OracleType.NVarChar).Value = dwData["TXT110"].ToString(); 
          or1.Parameters.Add("TXT110HR", OracleType.NVarChar).Value = dwData["TXT110HR"].ToString(); 
          or1.Parameters.Add("TXT110DT", OracleType.NVarChar).Value = dwData["TXT110DT"].ToString(); 
          or1.Parameters.Add("TXT120", OracleType.NVarChar).Value = dwData["TXT120"].ToString(); 
          or1.Parameters.Add("TXT120HR", OracleType.NVarChar).Value = dwData["TXT120HR"].ToString(); 
          or1.Parameters.Add("TXT120DT", OracleType.NVarChar).Value = dwData["TXT120DT"].ToString(); 
          or1.Parameters.Add("TXT130", OracleType.NVarChar).Value = dwData["TXT130"].ToString(); 
          or1.Parameters.Add("TXT130HR", OracleType.NVarChar).Value = dwData["TXT130HR"].ToString(); 
          or1.Parameters.Add("TXT130DT", OracleType.NVarChar).Value = dwData["TXT130DT"].ToString(); 
          or1.Parameters.Add("TXT140", OracleType.NVarChar).Value = dwData["TXT140"].ToString(); 
          or1.Parameters.Add("TXT140HR", OracleType.NVarChar).Value = dwData["TXT140HR"].ToString(); 
          or1.Parameters.Add("TXT140DT", OracleType.NVarChar).Value = dwData["TXT140DT"].ToString(); 
          or1.Parameters.Add("TXT150", OracleType.NVarChar).Value = dwData["TXT150"].ToString(); 
          or1.Parameters.Add("TXT150HR", OracleType.NVarChar).Value = dwData["TXT150HR"].ToString(); 
          or1.Parameters.Add("TXT150DT", OracleType.NVarChar).Value = dwData["TXT150DT"].ToString(); 
          or1.Parameters.Add("TXT160", OracleType.NVarChar).Value = dwData["TXT160"].ToString(); 
          or1.Parameters.Add("TXT160HR", OracleType.NVarChar).Value = dwData["TXT160HR"].ToString(); 
          or1.Parameters.Add("TXT160DT", OracleType.NVarChar).Value = dwData["TXT160DT"].ToString(); 
          or1.Parameters.Add("TXT170", OracleType.NVarChar).Value = dwData["TXT170"].ToString(); 
          or1.Parameters.Add("TXT170HR", OracleType.NVarChar).Value = dwData["TXT170HR"].ToString(); 
          or1.Parameters.Add("TXT170DT", OracleType.NVarChar).Value = dwData["TXT170DT"].ToString(); 
          or1.Parameters.Add("TXT180", OracleType.NVarChar).Value = dwData["TXT180"].ToString(); 
          or1.Parameters.Add("TXT180HR", OracleType.NVarChar).Value = dwData["TXT180HR"].ToString(); 
          or1.Parameters.Add("TXT180DT", OracleType.NVarChar).Value = dwData["TXT180DT"].ToString(); 
          or1.Parameters.Add("TXT190", OracleType.NVarChar).Value = dwData["TXT190"].ToString(); 
          or1.Parameters.Add("TXT190HR", OracleType.NVarChar).Value = dwData["TXT190HR"].ToString(); 
          or1.Parameters.Add("TXT190DT", OracleType.NVarChar).Value = dwData["TXT190DT"].ToString(); 
          or1.Parameters.Add("TXT200", OracleType.NVarChar).Value = dwData["TXT200"].ToString(); 
          or1.Parameters.Add("TXT200HR", OracleType.NVarChar).Value = dwData["TXT200HR"].ToString(); 
          or1.Parameters.Add("TXT200DT", OracleType.NVarChar).Value = dwData["TXT200DT"].ToString(); 
          or1.Parameters.Add("TXT210", OracleType.NVarChar).Value = dwData["TXT210"].ToString(); 
          or1.Parameters.Add("TXT210HR", OracleType.NVarChar).Value = dwData["TXT210HR"].ToString(); 
          or1.Parameters.Add("TXT210DT", OracleType.NVarChar).Value = dwData["TXT210DT"].ToString(); 
          or1.Parameters.Add("TXT220", OracleType.NVarChar).Value = dwData["TXT220"].ToString(); 
          or1.Parameters.Add("TXT220HR", OracleType.NVarChar).Value = dwData["TXT220HR"].ToString(); 
          or1.Parameters.Add("TXT220DT", OracleType.NVarChar).Value = dwData["TXT220DT"].ToString(); 
          or1.Parameters.Add("TXT230", OracleType.NVarChar).Value = dwData["TXT230"].ToString(); 
          or1.Parameters.Add("TXT230HR", OracleType.NVarChar).Value = dwData["TXT230HR"].ToString(); 
          or1.Parameters.Add("TXT230DT", OracleType.NVarChar).Value = dwData["TXT230DT"].ToString(); 
          or1.Parameters.Add("TXT240", OracleType.NVarChar).Value = dwData["TXT240"].ToString(); 
          or1.Parameters.Add("TXT240HR", OracleType.NVarChar).Value = dwData["TXT240HR"].ToString(); 
          or1.Parameters.Add("TXT240DT", OracleType.NVarChar).Value = dwData["TXT240DT"].ToString(); 
          or1.Parameters.Add("TXT250", OracleType.NVarChar).Value = dwData["TXT250"].ToString(); 
          or1.Parameters.Add("TXT250HR", OracleType.NVarChar).Value = dwData["TXT250HR"].ToString(); 
          or1.Parameters.Add("TXT250DT", OracleType.NVarChar).Value = dwData["TXT250DT"].ToString(); 
          or1.Parameters.Add("TXT260", OracleType.NVarChar).Value = dwData["TXT260"].ToString(); 
          or1.Parameters.Add("TXT260HR", OracleType.NVarChar).Value = dwData["TXT260HR"].ToString(); 
          or1.Parameters.Add("TXT260DT", OracleType.NVarChar).Value = dwData["TXT260DT"].ToString(); 
          or1.Parameters.Add("TXT270", OracleType.NVarChar).Value = dwData["TXT270"].ToString(); 
          or1.Parameters.Add("TXT270HR", OracleType.NVarChar).Value = dwData["TXT270HR"].ToString(); 
          or1.Parameters.Add("TXT270DT", OracleType.NVarChar).Value = dwData["TXT270DT"].ToString(); 
          or1.Parameters.Add("TXT280", OracleType.NVarChar).Value = dwData["TXT280"].ToString(); 
          or1.Parameters.Add("TXT280HR", OracleType.NVarChar).Value = dwData["TXT280HR"].ToString(); 
          or1.Parameters.Add("TXT280DT", OracleType.NVarChar).Value = dwData["TXT280DT"].ToString(); 
          or1.Parameters.Add("TXT290", OracleType.NVarChar).Value = dwData["TXT290"].ToString(); 
          or1.Parameters.Add("TXT290HR", OracleType.NVarChar).Value = dwData["TXT290HR"].ToString(); 
          or1.Parameters.Add("TXT290DT", OracleType.NVarChar).Value = dwData["TXT290DT"].ToString(); 
          or1.Parameters.Add("TXT300", OracleType.NVarChar).Value = dwData["TXT300"].ToString(); 
          or1.Parameters.Add("TXT300HR", OracleType.NVarChar).Value = dwData["TXT300HR"].ToString(); 
          or1.Parameters.Add("TXT300DT", OracleType.NVarChar).Value = dwData["TXT300DT"].ToString(); 
          or1.Parameters.Add("TXT310", OracleType.NVarChar).Value = dwData["TXT310"].ToString(); 
          or1.Parameters.Add("TXT310HR", OracleType.NVarChar).Value = dwData["TXT310HR"].ToString(); 
          or1.Parameters.Add("TXT310DT", OracleType.NVarChar).Value = dwData["TXT310DT"].ToString(); 
          or1.Parameters.Add("TXT320", OracleType.NVarChar).Value = dwData["TXT320"].ToString(); 
          or1.Parameters.Add("TXT320HR", OracleType.NVarChar).Value = dwData["TXT320HR"].ToString(); 
          or1.Parameters.Add("TXT320DT", OracleType.NVarChar).Value = dwData["TXT320DT"].ToString(); 
          or1.Parameters.Add("TXT330", OracleType.NVarChar).Value = dwData["TXT330"].ToString(); 
          or1.Parameters.Add("TXT330HR", OracleType.NVarChar).Value = dwData["TXT330HR"].ToString(); 
          or1.Parameters.Add("TXT330DT", OracleType.NVarChar).Value = dwData["TXT330DT"].ToString(); 
          or1.Parameters.Add("TXT340", OracleType.NVarChar).Value = dwData["TXT340"].ToString(); 
          or1.Parameters.Add("TXT340HR", OracleType.NVarChar).Value = dwData["TXT340HR"].ToString(); 
          or1.Parameters.Add("TXT340DT", OracleType.NVarChar).Value = dwData["TXT340DT"].ToString(); 
          or1.Parameters.Add("TXT350", OracleType.NVarChar).Value = dwData["TXT350"].ToString(); 
          or1.Parameters.Add("TXT350HR", OracleType.NVarChar).Value = dwData["TXT350HR"].ToString(); 
          or1.Parameters.Add("TXT350DT", OracleType.NVarChar).Value = dwData["TXT350DT"].ToString(); 
          or1.Parameters.Add("TXT360", OracleType.NVarChar).Value = dwData["TXT360"].ToString(); 
          or1.Parameters.Add("TXT360HR", OracleType.NVarChar).Value = dwData["TXT360HR"].ToString(); 
          or1.Parameters.Add("TXT360DT", OracleType.NVarChar).Value = dwData["TXT360DT"].ToString(); 
          or1.Parameters.Add("TXT370", OracleType.NVarChar).Value = dwData["TXT370"].ToString(); 
          or1.Parameters.Add("TXT370HR", OracleType.NVarChar).Value = dwData["TXT370HR"].ToString(); 
          or1.Parameters.Add("TXT370DT", OracleType.NVarChar).Value = dwData["TXT370DT"].ToString(); 
          or1.Parameters.Add("TXT380", OracleType.NVarChar).Value = dwData["TXT380"].ToString(); 
          or1.Parameters.Add("TXT380HR", OracleType.NVarChar).Value = dwData["TXT380HR"].ToString(); 
          or1.Parameters.Add("TXT380DT", OracleType.NVarChar).Value = dwData["TXT380DT"].ToString(); 
          or1.Parameters.Add("TXT390", OracleType.NVarChar).Value = dwData["TXT390"].ToString(); 
          or1.Parameters.Add("TXT390HR", OracleType.NVarChar).Value = dwData["TXT390HR"].ToString(); 
          or1.Parameters.Add("TXT390DT", OracleType.NVarChar).Value = dwData["TXT390DT"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
